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.
Day 2 Agenda: Complex functions Using the WITH statement Window functions Ranking data Point in time functions Using the APPLY function Tips and tricks Flattening data/rows to columns Lead and lag functions Data validation Deploying SQL queries in your tool Web Intelligence Crystal Reports InfoBurst Tableau Power BI Other database systems Compare/contrast RDBMS’s Syntactical differences […]
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 […]
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 […]
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 […]
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.