fbpx
Select Page
ETL vs. ELT: Which is Right for Your Company?

ETL vs. ELT: Which is Right for Your Company?

GUIDESETL vs. ELT: Which is Right for Your Company?Devon TackelsHead of Communications, SigmaAre you considering a move to a modern cloud data warehouse like Snowflake, BigQuery, or Redshift? If so, you’ve probably got a few questions about building the right data...
Don’t Dread KPI Reporting—Automate It Instead

Don’t Dread KPI Reporting—Automate It Instead

GUIDESDon’t Dread KPI Reporting—Automate It Instead Devon TackelsHead of Communications, SigmaIt’s that time of the month again. We all know the drill: it’s time to report on your team’s Key Performance Indicators (KPIs). There’s an executive meeting down the hall...
How to Build The Perfect Analytics Dashboard

How to Build The Perfect Analytics Dashboard

GUIDESHow to Build the Perfect Analytics DashboardSo, you’ve gotten your feet wet by exploring data in your cloud warehouse. Now you’re ready to shine a spotlight on your analysis and share it with coworkers or partners. This is where dashboards come in....
Find Latest Weekday and Previous Weekday

Find Latest Weekday and Previous Weekday

GUIDESFind Latest Weekday and Previous WeekdayCurrent WeekdayReturns the Date of the current or most recent weekday (Monday through Friday). If the input date is a Monday, the function returns the input date. If the input date is a Sunday, the function returns the...
Assign Your Data to Categories

Assign Your Data to Categories

GUIDESAssign Your Data to CategoriesSometimes you need to group your data into categories that are specific to your organization and the analysis you need to do. This could be grouping dates into Holiday seasons, defining revenue ranges, or even defining your...
Calculate Week Over Week Numbers

Calculate Week Over Week Numbers

GUIDESCalculate Week Over Week NumbersOnce you calculate your weekly numbers, calculating week over week numbers become very simple when using the Lag or Lead functions. Lag and Lead are Window Functions that shifts all of the rows in a column. The...

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.