Authored by

Luca Gualtieri

8 min read

Share this article

Cloud analytics in the age of self-service and data science

Analytics in a Day (AID) workshop is designed to simplify and accelerate your journey towards using a modern data warehouse to power your business.

The AID workshop teaches customers how to take advantage of analytics in the cloud, from data ingestion to business intelligence. Our role will be to guide workshop attendees through the presentation and hands-on lab. The presentation will explain key concepts and benefits while the lab will provide hands-on instruction on how to deploy an end-to-end analytics solution.

In our workshop, you will better understand how to:

  • Create an analytics pipeline that goes from data ingestion to insights using Power BI
  • Empower self-service analytics
  • Enable a truly data-driven culture in your business
  • Hand-On Azure Synapse
  • Understand the benefits of establishing a Center of Excellence (COE)
  • Design governance rules and standards
  • Design, optimize, and publish Power BI models and reports

Lab: Build an end-to-end analytics solution with Azure Synapse and Power BI

The hands-on lab session allow users to apply newfound knowledge. The new lab uses the new Azure Synapse Studio, as well as the new features that are currently available in public preview.

The labs will be integrated in the system provisioned by Spektra and there is no need to download them in advance.

The following GitHub repos contain the labs for backup purposes.

  • The Hands-on lab using the Azure Synapse Studio is based on this GitHub Repo. 
  • The Hands-on lab using the Azure Synapse Studio + Power BI is based on this GitHub Repo.

Azure Credits for AID attendees

Starting Aug 1, 2020, Analytics in a Day workshop attendees get access to $150 in Azure credits to continue their learning and exploration for up to 12 hours of Synapse up-time to be used within a week.

This will be enabled on the same lab environment used for workshop, including all the data-sets, and using the same set of credentials.

Workshop participant must ensure that they pause the SQL Pool, and terminate any spark pool clusters, to keep the total up-time below 12 hours.



Luca Gualtieri

Luca Gualtieri is a BI Consultant and a Microsoft Certified Professional in Azure Data Engineering and Analyzing and Visualizing Data with Power BI. He has over a decade of experience working as a consultant, business analyst, project manager and expert in data analytics and visualization. His passion for telling stories with data, and translating raw data into insightful metrics has helped firms and institutions around the globe. Learn more about Luca on LinkedIn or contact him directly at [email protected].

What to Know Before the Class

This course assumes you have familiarity with enterprise BI solution objectives, Azure Synapse Analytics and Power BI.

Online / Virtual Analytics in a Day Agenda

Times are approximate and will be fluid with the class.

Morning: Build an end-to-end analytics solution in the Azure Synapse Studio

  • 09:00 AM – 09:45 AM – The hearth of analytics
  • 09:45 AM – 10:30 AM – Optimizing analytics with Azure Synapse
  • 10:30 AM – 10:45 AM – Insights for all with Power BI + Azure Synapse
  • 10:45 AM – 11:00 AM – Break
  • 11:00 AM – 12:45 PM – Hands-on lab using the Azure Synapse Studio
  • 12:45 PM – 01:30 PM – Break for lunch

Afternoon: Azure Synapse + Power BI better together (Optional Module)

  • 01:30 PM – 01:45 PM – Microsoft BI Solution Methodology
  • 01:45 PM – 02:15 PM – Deliver Discipline at the Core
  • 02:15 PM – 03:00 PM – Lab - Develop a Power BI Model
  • 03:00 PM – 03:15 PM – Lab - Optimize the Power BI Model
  • 03:15 PM – 03:30 PM – Break
  • 03:30 PM – 04:00 PM – Deliver Flexibility at the Edge
  • 04:00 PM – 04:45 PM – Lab - Publish a Power BI Report
  • 04:45 PM – 05:00 PM – Q&A

Upcoming Sessions:

  • To be scheduled

Previous Sessions:

  • 20-Aug-2020
  • 08-Sep-2020


Our detailed articles, and technical white papers on the latest in BI news and technologies, curated and delivered to you via an editorial email newsletter.