Automate Your Data Warehouse & Power BI with AnalyticsCreator

This video from our recent webinar showed how to.

• Connect to a source data (Northwind Data Set)
• Used the AnalyticsCreator Wizard to specify how to process the meta data from the connector
• Create a custom transformation on the level of the relevant business key and calculate an amount based on the satellite data, creating a basic fact table
• Add a calendar dimension to the Fact table
• Deploy the database structures as well as the SSIS packages to a SQL Server
• Execute the workflow package, which ingests the data from the source tables to the target database and process it
• Load the star schema to Power BI and plot the calculated amounts in a diagram.

For more events and videos please refer to our Events Page