Azure Synapse Shorts – Table Distributions
Chris Seferlis explains why Azure Synapse is one of the leading platform for Cloud Scale Analytics in any Cloud. Part of the reason for that is the flexibility and capability that is provided to build your analytic solutions that will work best for you and your data. Of course that starts with performance, and most […]
Read More
Becoming a Data Driven Organization with Modern Lakehouse
I often say that “Data is the new oil,” but to transform it into anything useful, you need a high performing oil refinery. This talk by Databricks highlights the emerging “Lakehouse” pattern that’s taking enterprises by storm.
Read More
Dave Wentzel on Why You Don’t Need a Data Warehouse
In this episode of Data Driven, Frank and Andy chat with Philadelphia Microsoft Technology Center Data Architect Dave Wentzel on why you do not need a data warehouse. Also, Frank discusses leaving Microsoft, Frank and Andy talk about five seasons of Data Driven, and even BAILeY has a sentimental moment.Show NotesComing Soon. Press the play […]
Read More
Why Power BI loves a Star Schema
-
Frank
- February 25, 2021
- Data Analytics
- data model
- data modeling
- data modelling training
- Data Warehouse
- data warehousing tutorial
- datamart
- datawarehouse
- dimension table
- dimensions
- fact
- foreign key
- Microsoft
- Power BI
- power bi data modeling
- Power BI reports
- power bi star schema
- power bi star schema vs flat table
- power bi tutorial
- snowflake schema
Are you using a flat table in your Power BI report? You may be missing out! Patrick from Guy in a Cube explores what a STAR SCHEMA is and why you should be using it.
Read More
What Does Azure Synapse Mean for My Modern Data Warehouse?
Skill Me UP posted this session on what Synapse means for your modern data warehouse. In this session we will explore Azure Synapse, the interface, the technology and the development studio to evaluate what impact the latest Massively Parallel Processing compute engine in Azure will have on my existing or planned Modern Data Warehouse on […]
Read More
What is Azure Synapse Analytics?
-
Frank
- December 9, 2020
- analytics db
- Azure
- Azure Analysis Services
- azure cosmos db
- Azure Data Factory
- Azure Data Warehouse
- Azure SQL Data Warehouse
- Azure Stream Analytics
- Azure Synapse
- azure synapse vs snowflake
- Azure: Analytics
- Big Data
- Big Data analytics
- data ware house
- Data Warehouse
- data warehouse software
- enterprise data warehousing
- Machine Learning
- Microsoft
- Microsoft Power BI
- Power BI
- query data
- SQL Data Warehouse
- SQL DW
- Synapse
- synapse download
- synapse software
Azure Synapse is now generally available! Microsoft Mechanics explains why this is a game changer for analytics.
Read More
Connecting to External Data with Azure Synapse
In this video Chris Seferlis gives a quick demonstration of connecting an external data source to my Synapse environment and the differences in performance between connecting as an external table or querying directly off of blob storage. Then he goes into the difference in external table and how that differs from copying the data right […]
Read More
Delta Lakehouse Data Profiler and SQL Analytics Demo
Coming from a data warehousing and BI background, Franco Patano wanted to have a catalogue of the Lakehouse, including schema and profiling statistics. He created the Lakehouse Data Profiler notebook using Python and SQL to analyze the data and generate schema and statistics tables. He then uses the new SQL Analytics product from Databricks to […]
Read More
Azure Synapse, Predictive Maintenance, Safety, and Efficiency at GE Aviation
-
Frank
- July 1, 2020
- Azure Data Warehouse
- Azure SQL Data Warehouse
- Azure Synapse
- Azure Synapse Analytics
- azure warehouse
- Big Data
- big data processing
- Data Analytics
- data analytics tools
- Data Warehouse
- data warehouse architecture
- Data Warehousing
- microsoft azure analytics
- microsoft azure data warehouse
- microsoft azure sql data warehouse
- predictive maintenance
- predictive maintenance data
- predictive maintenance machine learning
- predictive maintenance technology
- processing data
Microsoft Mechanics shows us a practical use case for Predictive Maintenance, Safety, and Efficiency through Microsoft Azure Synapse. Find out how Azure Synapse is part of the next-generation data and analytics platform for global aviation tech company, GE Aviation. Jeremy Chapman speaks with Luke Bowman, Senior Product Manager at GE Aviation’s Digital Group, to discuss […]
Read More
Slowly Changing Dimensions (SCD) Type 2
Databricks recently streamed this tech chat on SCD, or Slowly Changing Dimensions. We will discuss a popular online analytics processing (OLAP) fundamental – slowly changing dimensions (SCD) – specifically Type-2. As we have discussed in various other Delta Lake tech talks, the reliability brought to data lakes by Delta Lake has brought a resurgence of […]
Read More%20Type%202){kind=link}