Adam Lange

Adam Lange

Consultant, Alcove Insights

Adam Lange is an analytics expert with a passion for data. He has worked mostly in higher education where he specializes in SAP BusinessObjects, Tableau, Power BI, and SQL database solutions.

Virtual: SQL for Data Analysts – Advanced (Day 2)

Day 2 Agenda: Complex functions Using the WITH statement Window functions Ranking data Point in time functions Using the APPLY function Deploying SQL queries in your tool Web Intelligence Crystal Reports InfoBurst Tableau Power BI Other database systems Compare/contrast RDBMS’s Syntactical differences   View Full Agenda: Day 1 Day 2

Post-Conference Boot Camp
READ MORE

Virtual: SQL for Data Analysts – Advanced (Day 1)

Course Description This hands-on course will help data analysts and report/dashboard developers to understand complex SQL concepts. Attendees will learn how to use complex calculations and functions, and how to use subqueries. Intended Audience: Data analysts and report/dashboard developers who want to expand their SQL skills. Prerequisites: At least one year of experience with SQL […]

Post-Conference Boot Camp
READ MORE

SQL for Data Analysts – Advanced (Day 2)

Day 2 Agenda: Complex functions Using the WITH statement Window functions Ranking data Point in time functions Using the APPLY function Deploying SQL queries in your tool Web Intelligence Crystal Reports InfoBurst Tableau Power BI Other database systems Compare/contrast RDBMS’s Syntactical differences VIEW DAY 1 AGENDA

Post-Conference Boot Camp
READ MORE

SQL for Data Analysts – Advanced (Day 1)

Course Description This hands-on course will help data analysts and report/dashboard developers to understand complex SQL concepts. Attendees will learn how to use complex calculations and functions, and how to use subqueries. Intended Audience: Data analysts and report/dashboard developers who want to expand their SQL skills. Prerequisites: At least one year of experience with SQL […]

Post-Conference Boot Camp
READ MORE

Flattening Your Data in Web Intelligence

It’s one of the most common problems in Web Intelligence reports. You’ve got rows and rows of data that you want to condense and flatten into a more horizontal format that is easier for your end-users to consume. This session will offer clear and easy-to-understand solutions for how you can pivot, flatten, and simplify the […]

BusinessObjects Reporting
READ MORE

A Brief SQL Introduction for Report Developers

Understanding and developing SQL queries is a vital skill for data analysts at all levels, as it is still the best way to communicate directly with your database. This session will explore the fundamentals of SQL querying with an emphasis on those topics that are most important for report and dashboard developers. Attendees will gain […]

BusinessObjects Reporting
READ MORE

Battle of the Dashboards

We developed the same dashboard using some of the most popular visualization tools: Tableau, Power BI, and Web Intelligence. Join us for an exciting live demonstration of the dashboards from each product. We will compare the features, usability, and presentation from each product, so YOU can decide which tool did it best.

Dashboards and Data Visualization
READ MORE