Home
Search results “Excel sql analysis services”
Creating Excel Reports with SQL Server or Analysis Server
 
08:16
A simple overview of how people use Excel to get reports from SSAS
Views: 4612 Randal Root
How to quickly generate connection string using Excel for SQL Server or Analysis Services
 
03:08
In this video you will learn how to create connection string for SQL Server or Analysis services in Excel and then you can use in Applications or such as Microsoft Dynamics to make connection to Analysis services. You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge
Views: 17503 TechBrothersIT
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA
 
11:34
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA If your manager needs the report very frequently then you need to do the same task again and again. Frankly speaking, I faced this kind of situation in my previous company and I prepared the report using VBA and handed over the file to my manager. Now, whenever he will click the button he will get the report of the LIVE DATA from SQL to Excel. You can read our blog to go through instructions as well as download working and code files, Click here: http://yodalearning.com/tutorials/export-data-from-sql-to-excel-spreadsheet-using-vba/ You can enroll in our Excel VBA course: http://courses.yodalearning.com/p/excel-vba-tutorials CHECK SOME OF THE FREE COURSES WE OFFER http://courses.yodalearning.com/p/free-office-2016-tips Keep yourself updated. Follow us now! http://www.facebook.com/yodalearning http://www.twitter.com/yodalearning
Views: 101725 Yoda Learning Official
Introduction to Data Mining in SQL Server Analysis Services
 
01:27:07
Data mining is one of the key hidden gems inside of Analysis Services but has traditionally had a steep learning curve. In this session, you'll learn how to create a data mining model to predict who is the best customer for you and learn how to use other algorithms to spend your marketing model wisely. You'll also see how to use Time Series analysis for budget and forecast prediction. Finally, you'll learn how to integrate data mining into your application through SSIS or custom coding.
Views: 12111 PASStv
Part 1 - Cube Funktionen mit Excel und SQL Server Analysis Services
 
13:19
Cube Funktionen in Excel 2007 + 2010 Kombination mit SQL Server Analysis Services Mehr zu Microsoft SQL Server und Business Intelligence auf http://saschalorenz.blogspot.com.
Views: 8749 Sascha Lorenz
Обзор SQL Server 2008 Analysis Services
 
11:50
В докладе дается краткое введение в OLAP и рассказывается об основных новшествах в текущей версии SQL Server.
Install SQL Server Analysis Services (SSAS, MOLAP 2014)
 
05:00
Install SQL Server 2014 - Analysis Services (SSAS, MOLAP) For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 19386 SQL with Manoj
Create & Publish a Data Cube for SQL Server Analysis Server
 
07:54
This video shows how to use Business Intelligence Development Studio (BIDS) to create an data cube for SQL Server Analysis Server 2008 This demo shows how to: Use BIDS to create a data model project Create Data Sources, Data Views, Dimensions, & Cubes Deploy the project to SSAS 2008
Views: 155900 DeveloperVideos
Sales Forecasting with Excel and the SQL Server 2012 Data Mining Add-in Tutorial
 
04:30
Use the Excel Data Mining add-in for SQL 2012 Analysis Services. See how simple it is to build a predictive model that forecasts sales or other values based on historical data.
Views: 12911 Edward Kench
Developing a SQL Server Analysis Services–Tabular Model
 
16:33
This vlog helps you develop interactively a tabular model. A quick semantic cube for all your dashboard needs.
Views: 16982 Keshav Singh
Intro to SQL Server Analysis Services
 
20:10
Intro to SQL Server Analysis Services by Jon Bloom at Bloom Consulting.
Views: 14679 Jon Bloom
SQL Server Analysis Services 2014: табличная модель
 
27:25
SQL Server Analysis Services 2014: табличная модель - альтернатива кубам?
Analysis Services tutorial. Creating OLAP cube. Introduction to data warehouse
 
14:17
Analysis Services is a collection of OLAP supplied in Microsoft SQL Server. See more lessons https://www.youtube.com/watch?v=juKEUbav5kg&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC Lesson 1: Analysis Services Tutorial - Introduction https://www.youtube.com/watch?v=juKEUbav5kg&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=1 Lesson 2: Working with dimensions https://www.youtube.com/watch?v=1q8UZ945d70&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=2 Lesson 3: Aggregations https://www.youtube.com/watch?v=eXUdgOsbPu8&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=3 Lesson 4: Partitions https://www.youtube.com/watch?v=9QQlc60k-3Y&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=4 Lesson 5: OLAP Processing https://www.youtube.com/watch?v=JMppghX86Z8&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=5 Lesson 6: Automatically Processing https://www.youtube.com/watch?v=499BtNjFx30&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=6 Lesson 7: Role and Security https://www.youtube.com/watch?v=YX6Fg5kWUsU&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=7 Lesson 8: #MDX https://www.youtube.com/watch?v=gicnvI86XdQ&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=8 Lesson 9: KPI: Key Performance Indicators https://www.youtube.com/watch?v=ymPDKnmreDI&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=9 Lesson 10: Actions https://www.youtube.com/watch?v=Y4V3kkgr9pA&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=10 Lesson 11: Monitoring Cube Activity https://www.youtube.com/watch?v=KiY67RlfViY&list=PL99-DcFspRUqBoCUN0b-dzHjWAX-3xyWC&index=11
Creating Association Rules using the SQL Server Data Mining Addin for Excel
 
06:16
Association Rules are a quick and simple technique to identify groupings of products that are often sold together. This makes them useful for identifying products that could be grouped together in cross-sell campaigns. Association rules are also known as Market Basket Analysis, as they used to analyse a virtual shopping baskets. In this tutorial I will demonstrate how to create association rules with the Excel data mining addin that allows you to leverage the predictive modelling algorithms within SQL Server Analysis Services. Sample files that allow you follow along with the tutorial are available from my website at http://www.analyticsinaction.com/associationrules/ I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 7952 Steve Fox
Connect SQL Server from Excel and retrieve data
 
07:01
Connect SQL Server from Excel and retrieve data My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 40503 SQL with Manoj
SQL 2012 Analysis Services Calendar Dimension - Software Development Tutorial
 
08:48
Use Microsoft SQL Server 2012 Analysis Services to automatically generate and populate a time, date, or calendar dimension table. This type of dimension is commonly used in business analytics applications such as sales reporting. Software engineering tutorial.
Views: 20790 Edward Kench
Establishing a Connection to Microsoft SQL Server Analysis Services (SSAS) Cubes
 
03:10
This video will show you how to connect to an SSAS Cube from within Microsoft Excel.
Views: 2538 Fordham BI
SSAS - Creando un Cubo multidimensional con SQL Server Analysis Services
 
12:54
El siguiente vídeo muestra como crear un cubo multidimensional utilizando SQL Server Analysis Services a partir de la base de datos multidimensional Northwind Mart, así como explotar la data del cubo utilizando tablas dinámicas en Excel. #SSIS #VisualStudio #SSAS #SQLServer
Views: 4693 Renzo Caceres Rossi
Demo: Creating an Excel 2010 PivotTable Using a SQL Server 2008 R2 Analysis Services Cube
 
05:46
This demo shows how to create an Excel 2010 PivotTable using an SQL Server 2008 R2 Analysis Services cube. The PivotTable will support interactive filtering with a slicer and incorporate calculations from the cube. Presenter: Peter Myers, Mentor, Solid Quality Mentors.-Courtsey MSN Channel9 An
How to Install SQL Server 2016 Analysis Services - SQL Server 2016 DBA Tutorial
 
08:22
How to Install and Configure SQL Server 2016 Analysis Services 1. SSAS 2016 installation step by step 2. What are pre-requisites of SQL Server 2016 Analysis Services 3. How to add SSAS 2016 to an existing SQL Server 4. When to choose Multidimensional Data and Mining mode 5. When to Choose Tabular Mode 6. When to Choose PowerPivot Mode 7. SSAS 2016 Installation best practices 8. SSAS 2016 Configuration best practices 9. How to connect to Analysis Services using SQL Server Management Studio Link to scripts used in SQL Server2016 DBA tutorial http://www.techbrothersit.com/2017/03/how-to-install-and-configure-sql-server_24.html Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQLServer 2016 DBA tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 13725 TechBrothersIT
04 Create Excel Report from MS SQL Server Using Analysis Service Method3
 
10:35
with Arabic content by easy way to learn شرح بالعربي
Introduction to SQL Server Analysis Services (SSAS)
 
01:03:31
Check Out Our SSAS Blog - http://blog.pragmaticworks.com/topic/ssas In this session, you’ll learn how to build a highly efficient analytical platform by using Analysis Services (SSAS). You’ll learn the how to create and configure a cube to pre-aggregate your data and then how to create hierarchies to make your users more effective. Lastly, you will learn about the major difference between Multidimensional and Tabular Analysis Services and how each play different roles.
Views: 5629 Pragmatic Works
Part 2 - Cube Funktionen mit Excel und SQL Server Analysis Services
 
12:45
Cube Funktionen in Excel 2007 + 2010 Kombination mit SQL Server Analysis Services Mehr zu Microsoft SQL Server und Business Intelligence auf http://saschalorenz.blogspot.com.
Views: 3026 Sascha Lorenz
Forecast the Price of Gold with Excel and SQL Server - Data Mining Tutorial
 
06:15
Learn about data mining with SQL Server 2012 Analysis Services and Excel 2013, using historical gold pricing data, to predict future prices. To follow this tutorial, you should have SSAS and the Data Mining Add-in for Excel.
Views: 6615 Edward Kench
Create Pivot Table report in Excel by connecting SQL Server
 
04:00
Create Pivot Table report in Excel by connecting SQL Server My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 4366 SQL with Manoj
Getting Started with Azure Analysis Services
 
33:31
In this Webinar you will meet the Analysis Services team (such as Josh Caplan and Kay Unkroth) where they will show you the easiest way to get started with Analysis Services. If you aren't familiar with Azure Analysis Services, Azure Analysis Services provides enterprise-grade data modeling in the cloud. This enables you to mashup and combine data from multiple sources, define metrics, and secure your data in a single, trusted semantic data model. The data model provides an easier and faster way for your users to browse massive amounts of data with client applications like Power BI, Excel, Reporting Services, third-party, and custom apps. https://azure.microsoft.com/en-us/services/analysis-services/ Follow us on Twitter - https://twitter.com/mspowerbi More questions? Try asking the Power BI Community @ https://community.powerbi.com/
Views: 14330 Microsoft Power BI
How to Attach and Detach a SQL Server Analysis Services Database
 
10:47
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here: http://www.learnitfirst.com/Course165 In this video Scott will walk you through how to move a database (server to server, instance to instance, disk to disk, and folder to folder) in analysis services. There is a new feature in SSAS 2008 that will allow you to attach and detach an Analysis Services database. Highlights from this video: - What is the purpose of attach and detach? - Detach cannot have an open connection - Different techniques to move a database - Attach - Backup and restore (covered in next video) - How to detach and attach an Analysis Services database and much more...
Views: 7304 LearnItFirst.com
Excel Tutorial: What is Business Intelligence and an OLAP Cube? | ExcelCentral.com
 
10:18
This video lesson fully explains the concepts of Business Intelligence, OLAP, MDX and and how they apply to Excel 2013. At http://ExcelCentral.com you can view over 850 free Excel video lessons just like this one. All in full HD with vari-speed and human-transcribed subtitles providing the perfect Excel learning environment. You can also track your progress through the course and print a certificate upon completion. Separate videos are provided for Excel 2007, Excel 2010 and Excel 2013. The lesson begins with an explanation of OLAP and its purpose. You'll learn about OLAP Cubes and how they are divided into Dimensions, Measure and Hierarchies to create a multidimensional data structure. You'll also learn about how the MDX query language is used to extract values from OLAP cubes. This lesson also explains the concept of Business Intelligence and how it applies to OLAP. This video comes from the Data Model, OLAP, MDX and BI session (Session 6 in our Excel 2013 Expert Skills free video training course). This session includes the following video lessons: ▪ Lesson 6-1: Understand primary and foreign keys (11m 27s) http://excelcentral.com/excel2013/expert/lessons/06010-understand-primary-key-foreign-key-relationships.html ▪ Lesson 6-2: Create a simple data model (6m 31s) http://excelcentral.com/excel2013/expert/lessons/06020-create-a-simple-data-model.html ▪ Lesson 6-3: Understand OLAP, MDX and Business Intelligence (10m 17s) http://excelcentral.com/excel2013/expert/lessons/06030-what-is-business-intelligence-and-an-olap-cube.html ▪ Lesson 6-4: Use the GETPIVOTDATA function (4m 31s) http://excelcentral.com/excel2013/expert/lessons/06040-use-the-getpivotdata-function.html ▪ Lesson 6-5: Use the CUBEVALUE function to query an OLAP cube (5m 40s) http://excelcentral.com/excel2013/expert/lessons/06050-use-the-cubevalue-function-to-query-an-olap-cube.html ▪ Lesson 6-6: Convert CUBEVALUE functions to include MDX expressions (5m 48s) http://excelcentral.com/excel2013/expert/lessons/06060-convert-cubevalue-functions-to-include-mdx-expressions.html ▪ Lesson 6-7: Understand OLAP pivot table limitations (10m 52s) http://excelcentral.com/excel2013/expert/lessons/06070-understand-olap-pivot-table-limitations.html ▪ Lesson 6-8: Create an asymmetric OLAP pivot table using Named Sets (4m 57s) http://excelcentral.com/excel2013/expert/lessons/06080-create-an-asymmetric-olap-pivot-table-using-named-sets.html ▪ Lesson 6-9: Understand many-to-many relationships (11m 5s) http://excelcentral.com/excel2013/expert/lessons/06090-understand-many-to-many-relationships.html ▪ Lesson 6-10: Create an OLAP pivot table using a many-to-many relationship (12m 47s) http://excelcentral.com/excel2013/expert/lessons/06100-create-an-olap-pivot-table-using-a-many-to-many-relationship.html You can watch any of the 850 Excel video lessons, free and without any required registration at http://excelcentral.com/excel2013/expert/tutorials/default.html.
Views: 259377 ExcelCentral.com
What is SQL Server Analysis Services?
 
05:07
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here: http://www.learnitfirst.com/Course165 This quick video will go over what exactly Analysis Services is. You already know the basics of data warehousing, so now you will be able to understand the basics of Analysis Services. Highlights from this video: - Why didn't this video come earlier? - Data warehousing server - SSAS - Users' reporting needs and much more...
Views: 103023 LearnItFirst.com
MDX Query Basics (Analysis Services 2012)
 
13:09
This video is part of LearnItFirst's SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here: http://www.learnitfirst.com/Course170 In this video, we walk through the basics of the MDX Query language. It is a very logical language, however, is somewhat large in syntax. If you enjoy writing Transact-SQL, you will really enjoy the MDX language. The AdventureWorks2012 multidimensional models need to be installed on your SSAS Multidimensional mode instance from the CodePlex web site. Highlights from this video: - The basics of an MDX query - What is the basic format of the MDX query language? - Is it necessary to have a WHERE clause in an MDX query? - How to signal the end of a statement in the MDX query language - Using the Internet Order Count and much more...
Views: 110307 LearnItFirst.com
Zugriff auf Analysis Services aus Excel [SQL Server 2012: Ein Überblick]
 
04:56
http://www.video2brain.com/de/videotraining/sql-server-2012-ein-ueberblick Dieses Video ist ein Auszug aus Jörg Knuths und Markus Raatz' neuem Video-Training „SQL Server 2012: Ein Überblick. Konfiguration, Administration, Programmierung." von video2brain. Über dieses Video Entscheidender Vorteil eines Cubes ist, dass man in Excel so wunderbar einfach auf die im Cube enthaltenen Daten zugreifen kann.
How to Attach and Detach a SQL Server Analysis Services Database
 
10:47
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here: http://www.learnitfirst.com/Course165 In this video Scott will walk you through how to move a database (server to server, instance to instance, disk to disk, and folder to folder) in analysis services. There is a new feature in SSAS 2008 that will allow you to attach and detach an Analysis Services database. Highlights from this video: - What is the purpose of attach and detach? - Detach cannot have an open connection - Different techniques to move a database - Attach - Backup and restore (covered in next video) - How to detach and attach an Analysis Services database and much more...
Views: 15570 LearnItFirst.com
Création d’un cube OLAP en SQL Server Analysis Services
 
22:59
Lien pour télécharger le script: http://adf.ly/1VUNIC
Views: 8433 Allae Erraissi
Excel Lesson 34 - Import Data Using SQL Queries & Stored Procedures From SQL Server To Excel
 
06:40
Learn How To Import Data Using SQL Queries & Stored Procedures From SQL Server To Excel Database connectivity can be a very powerful tool, with which you can get real time refresh-able data which you can use for data analysis, creating dashboards etc. This method does not use VBA Coding and hence can be learnt by any excel user who does not know VBA Programming. My Website - www.NeedForExcel.com
Views: 9985 Need For Excel
Creating Basic Reports from an SQL Server Analysis Services Cube
 
19:02
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here: http://www.learnitfirst.com/Course165 In this video, Scott will show you how to create Basic reports using an analysis services cube. You will see the process behind creating reports in Reporting Services and how to effectively customize them to your needs. Highlights from this video: - How do you make a connection? - Shared vs Non-shared - Selecting and sorting data - Export data to excel, word, etc. - Using Report Wizard and much more...
Views: 3338 LearnItFirst.com
SSAS OLAP Cube Access from Excel - SQL Server 2012 - Kalman Toth
 
06:00
PivotTable OLAP cube demo. SQL Server 2012 book: ~ http://amzn.to/13yb23Y ~ SQL Programming & Database Design Using Microsoft SQL Server 2012 [Paperback] .
Views: 2152 SQLUSA
Budgeting with Power BI, for Power BI and SQL Server Analysis Services users
 
56:28
Budgeting is one of the most challenging scenarios in the Power BI arena. For example, you might need to summarize sales in previous years and to allocate the budget forecasts. You have to work with data at different granularities and to find a way to author DAX code to compute the forecasts at the desired granularity. When it comes to budgeting, each company is a unique scenario. In this session, you will see some common techniques to use when building a budget model with Power BI, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on products that do not yet exist. Vortrag in Englisch Presented by Alberto Ferrari (Founder & Business Intelligence consultant, sqlbi) @ PASS Austria SQL Community Meeting 05-2017 in Wien
Views: 4843 PASS Austria
How to Create and Publish a Data Cube using SQL Server Analysis Services
 
13:07
SQL Server Analysis Service | Creating Data Cube using Baseness Intelligence Development Studio
Views: 3308 Mhmoud Alkahlout
Creating Basic Reports from an SQL Server Analysis Services Cube
 
19:02
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here: http://www.learnitfirst.com/Course165 In this video, Scott will show you how to create Basic reports using an analysis services cube. You will see the process behind creating reports in Reporting Services and how to effectively customize them to your needs. Highlights from this video: - How do you make a connection? - Shared vs Non-shared - Selecting and sorting data - Export data to excel, word, etc. - Using Report Wizard and much more...
Views: 73738 LearnItFirst.com
Shopping Basket Analysis with Excel 2007 and SQL Server Data Mining
 
04:39
Watch this short tutorial video to learn how to do basket analysis with Excel 2007 and the SQL Server Data Mining add-in. You can download the SQL Server Data Mining add-in here http://www.microsoft.com/sqlserver/2008/en/us/data-mining-addins.aspx Get more information at http://blogs.msdn.com/bi
Views: 22142 wowmsft
Power BI Academy: Power BI with SQL Server Analysis Services
 
09:26
SQL Server or SQL Server Analysis Services are rock solid platforms for creating a Semantic Data Layer, to centralize intelligence and business logic across your organization and upon which to build Power BI Dashboards. This video demonstrates a very basic setup from SSAS to a basic Power BI Dashboard. http://www.freshbi.com
Introduction to Self Service BI: Tabular Data and SQL 2012
 
01:21:04
Using Microsoft Excel, PowerPivot, and Analysis Services, learn how to easily build and query a tabular OLAP data source.
Views: 5082 Jeff King
Excel - How to Connect from Microsoft Excel to Data Cubes on SQL Server
 
03:25
With a data warehouse on Microsoft SQL Server and analysis cubes running on Microsoft SQL Server Analysis Services, you can analyse, perform what-if analysis, prepare projections and budgets etc using Microsoft Excel. This particular video shows how you can establish a data connection from Microsoft Excel to analysis cubes running on Microsoft SQL Server Analysis Services.
Views: 9330 Flameater Flameater
47-How to quickly generate MDX Query by using SQL Profiler Or OLAP Pivot Table Extension
 
12:01
In this video you will learn how to generate MDX Query. The reason we need to generate query for one of a Reporting that need to extract data from Cube. There are multiple ways to generate MDX, Couple of them are below Using SQL server Profiler Using OLAP Pivot Table Extension How to generate MDX Query from SQL Server Profiler How to generate MDX Query from OLAP Pivot Table Extension Generate MDX Query Generate MDX query for Reporting Services Generate MDX query from Excel
Views: 5840 TechBrothersIT
Deep dive into data modeling using Power BI desktop and SQL Server Analysis Services
 
01:05:41
The Analysis Services model used in both Power BI Desktop and SSAS allows solving of very complex modelling issue. In this session we will look at solving several complex modelling problems like many-to-many using the latest version of Power BI desktop and Analysis Services.
Views: 6984 chassMSFT
Data Mining in SQL Server Analysis Services
 
01:29:25
Presenter: Brian Knight
Views: 98799 PASStv
What's new in PowerPivot for Excel with SQL Server Code Name "Denali" CTP3
 
06:34
Julie Strauss from the Analysis Services Team provides an overview of what PowerPivot is, the benefits to users, and some details on the new SQL Server "Denali" PowerPivot for Excel that accompanies SQL Server Code Name "Denali" CTP3. Download SQL Server Code Name "Denali" CTP3 at: http://www.microsoft.com/denali Download SQL Server "Denali" PowerPivot for Excel at: http://www.microsoft.com/download/en/details.aspx?id=26721
Views: 4838 sqlserver
Ragged Hierarchies in Analysis Services with Power BI and Excel
 
07:44
In this video, Patrick looks at the ragged hierarchy problem within Excel and Power BI when you are pulling data from Analysis Services. He looks at how you can correct the issue easily within Excel and some alternatives for Power BI. LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/
Views: 9168 Guy in a Cube
SQL Server Analysis Services (Crear Cubo)
 
22:33
Como podemos crear un cubo para llevar los datos a excel en este video tutorial lo podemos hacer
Views: 831 Milton Tenorio
Analysis Services - 04 Cube Creation
 
21:06
So we have created our logical view of our data it's now time to create our cube...or is it? Can I create a Cube So Soon? The Microsoft textbook response is you can tackle Cube creation head on once you have established your Data Source and Data Source View. Yet there is something quite vital we are missing from our current developments which are dimensions. Dimensions (which we will get to shortly via several videos) are the text-based values you are going to want to place next to your Cube aggregations. E.g. If you have total sales in your Cube you probably will want to present that with perhaps a region or customer? Well the Cube Wizard handles creating these dimensions for you. Albeit not to the degree you will wish. You will soon find that the wizard is a good starting point but will lack the finesse you will be needing to apply to make a fully functional cube. But for the newbie coming to SSAS for the first time this is quite a sense of achievement and rightly so, you have traversed OLTP to OLAP using ETL in SSIS to reach SSAS. Boy I have just reliased how much I.T. relies on acronyms :)
Views: 56443 PCTeachME