SSAS - From Beginner to Pro - The practical Cube Tutorial

Download SQL Server 2017 developer edition and install with custom features including database engine service, integration services, analysis services, and machine learning services with R and Python.

Install the SQL Server front end via the installation center, download and install the Secret Service Management Studio, then verify the setup in the server tools folder.

Install a development environment by downloading and installing the SSD standalone tools, creating a new named instance called Peetie, and enabling database, analysis, reporting, and integration services for SSAS cubes.

Install and connect to the database engine via management studio, then run the data script to create your DMU training English database with article, customer, and time tables.

Browse and interpret tables in SSMS to understand unique identifiers like position ID and article ID, and the structure of sales data for building SSAS cubes.

Set up a data connection for a multidimensional SSAS cube in Visual Studio 2017, configure the data source, test the connection, and build the data source view with four tables.

Set up the query editor environment to prepare a cube by inspecting and renaming table columns, using diagram, grid, and SQL panes, and exploring joins for a star schema.

Explore the star schema concept by linking a orders fact table to descriptive dimension tables like product and time, using primary and foreign keys to connect metrics and dimensions.

Establish primary and foreign keys to connect a sales fact table to article, customer, and time dimensions in an SSAS cube, ensuring correct dimensional relationships for easy processing.

Process the cube with the cube wizard by selecting existing tables, defining measures (quantity, value) and dimensions (article, time, customer), then deploy and run a full process in analysis services.

Browse the cube to understand data by adding fields, mapping attributes, and building queries in data source view; learn to process, deploy, and troubleshoot with drag-and-drop and auto-execute features.

Add a new invoice customer dimension to an existing cube by using the invoice customer ID, linking it to sales, configuring the dimension usage, and processing with error handling.

Explore processing error messages like a missing customer for a sales invoice, and learn three fixes: consult technical support, ignore arrows, or use a SQL union.

Explore adding translations to the SSAS cube using the translations tab, implement multilingual labels for measures and dimensions with English as the default and German as an example.

Learn to create calculated measures in a cube using drag-and-drop and MDX. Build metrics like average sales and quantity, across countries and customers, with fast, visual tooling.

Learn to create drill-through actions in SSAS cubes using the action organizer. Define return columns such as measures, customer country, product group, and time.

Learn to add a time dimension in SSAS by generating a time table from the data source, configuring start date and calendars, then integrating it into the data source view.

Learn to create new roles in SSAS, assign read permissions, and securely restrict cube data access using Active Directory groups and dimension data for country-specific access, such as Germany.

Learn how to create hierarchies in SSAS by organizing dimension attributes into levels (region, country, name) to improve query performance and end-user usability.

Automate cube processing using a new SSIS integration services project, configure connection managers, and schedule a SQL Server Agent job to process the whole sales cube daily at 6:00 a.m.

Fix time sorting common problems in SSAS cubes by ordering months by key, not name, using the time dimension's order by key settings and year-month keys.

Learn how to create an ssas cube from start to finish: build the data source and view, define measures and dimensions, create the cube and roles, and process for deployment.

Connect Excel to an Analysis Services cube, retrieve data with pivot tables, and work with measures, dimensions, filters, slicers, and drill-through actions, and security roles.

Learn how to connect to Power BI with data connectors, build reports via import or live connections to SSAS, and share insights across mobile and web.

Create db objects for a purchasing cube by running a sequence script that creates tables such as employees, purchasing process, supplier, time, and articles, enabling data setup.

Set up a SAS project for purchasing, build a purchasing cube with measures value, amount, and count purchases, and dimensions employees, timetable, products, suppliers, and purchasing process, then connect them.

Set up a data source for the purchasing cube in Visual Studio by creating a new data source and using a service account impersonation. Then create the data source view.

Create and configure a data source view to build the cube, establish a star schema with article, employees, purchasing, supplier, and time, and set primary keys and relationships.

Learn how to create an ssas solution cube from existing tables, select measures from the purchasing process, add dimensions and attributes, process and deploy, and configure security roles.

Explore three planning methods in a business intelligence context—web front end, Excel file, and cube backend—discussing strengths, tradeoffs, and when to use each for departmental vs enterprise planning.

Learn to enable cube writeback, use what-if analysis in pivot tables to adjust plan sales and recalculate achieved percentages, publish changes, and propagate updates to all users with controlled permissions.

Create a writeback cube by building a small sales planning measure group, configure relationships to date and customer, enable what-if analysis, process and publish changes to the server.

SSAS from beginner to pro with a practical cube tutorial, learning to create cube solutions and set up data analysis projects through hands-on practice.