From the course: Learning Data Analytics: 1 Foundations
Join today to access over 25,300 courses taught by industry experts.
Working with connections
From the course: Learning Data Analytics: 1 Foundations
Working with connections
- [Instructor] You may have learned how to build some pretty powerful data sets already just using flat files. You may discover that leveraging connections to data will actually enhance your productivity and be easier for you on your refreshes. If there's one specific area in data software that has grown besides cleaning and transforming and visualizing data, it's the connections to the data. I can remember early in my career that some of the only ways I could connect to certain data at some companies was actually through ODBC connections that were set up on my machine by the IT group. Today, just good old fashioned Excel will tap into a lot of live data sources. Let's take a look. Okay, so I'll go to Data and Get Data. Now, if I'm choosing things like From File, of course, I'm pulling in probably a flat file. But look, I can connect to all sorts of databases. Assuming that I have a username and permissions to that file, I'm able to tap into it from Excel. You also see other services…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.